﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;

/// <summary>
/// Summary description for DoctorClass
/// </summary>
public class DoctorClass:BaseClass
{
    public static DataTable DonorData(string ValueOfSearch)
    {
        string q = "select DONORS.NAME ,RESULT.HEMOGLOBINRATIO as HEMO,RESULT.BLOODGR ,RESULT.HBSAG,RESULT.HCVAB,RESULT.HIV,RESULT.SYPHILIS ,DONATIONPROCESS.dateOFLASTDONATION as Date FROM DONORS , RESULT , DONATIONPROCESS WHERE DONORS.ID=DONATIONPROCESS.ID AND DONATIONPROCESS.BARCODE=RESULT.SAMPLE_NO AND DONORS.ID = '" + ValueOfSearch + "' ";
        string Query = string.Format(q);
            return BaseClass.RunSelect(Query);

    }
}